     
    
  
  
      
 
     
      

            syntax error
    "ok"
              

xlSheet2.Range("e2").Formula = "=ROUND(IF('sheet1'!c2="ok",IF(d2<=2969,d2,2969),IF(d2<=2500,d2,2500)),2)"
